home *** CD-ROM | disk | FTP | other *** search
- MOD (Modulo)
- Calculates the remainder when the number is divided by divisor-number. The result has the same sign as the value in number.
-
- Format: MOD (number, divisor-number)
-
- Arguments:
- ΓÇó number: A number, cell reference, or arithmetic operation.
- ΓÇó divisor-number: Must not be 0.
-
- Example:
- MOD (4.5, -2) returns 0.5.
- Shows that negative numbers can be used, but the sign of the result is that of the dividend (4.5), not the divisor.